FleetManagementCharge

Entity Definition

Logical Name : FleetManagementCharge
Physical Name : TR_FLE_MGMT

Vehicle, Driver & other fleet management data that is collected as part of the process of tendering a transaction (that includes the sale of a FuelItem) with a CustomerAccount.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32)
RetailTransactionLineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint
LicensePlateIssuerCode (FK) A unique system generated identifier for the external agency that provides Party Identification codes for People and Organizations. Eg: Dun & Bradstreet, Standard & Poors, NYSC, NASDAQ, UCC for Organizations. Various government agencies for People, eg: SocialSecurity, Health Administration, Drivers Licensing, etc. ID_PA_PVR_EXTRN Identity integer ExternalPartyIdentificationProvider(PA_PVR_EXTRN_IDTN)
LicensePlateNumber The license plate number for the vehicle being fueled. ED_LSC_PLT IdentityAlphaNumeric varchar(20)
VehicleID A unique customer assigned identifier for the vehicle being fueled. Usually this will be the vehicle's license plate number, but not always. ID_VH IdentityAlphaNumeric varchar(20)
DriverID A unique customer assigned identifier for the driver making the purchase. ID_DRV IdentityAlphaNumeric varchar(20)
WorkOrderID A unique customer assigned identifier for the job or work-order that the purchase will be attributed to by the customer. ID_WRK_ORD IdentityAlphaNumeric varchar(20)
TemporaryVehicleFlag A flag denoting that this fleet information refers to a temporary vehicle, which means there is no valid VehicleID present. FL_VH_TMP Flag integer
OdometerReading The OdometerReading for the vehicle being fueled. QU_RDG_ODO Quantity DECIMAL(9,3)

Relationships

Parent Entity Verb Phrase Child Entity
ExternalPartyIdentificationProvider classifies FleetManagementCharge
CreditDebitCardTenderLineItem can be a FleetManagementCharge

Logical Views containing FleetManagementCharge

Logical View
Logical 02300 - Retail Transaction - Macro View
Logical 02330 - Retail Transaction - Tender - Macro View